Dataset info
| Number of variables | 34 |
|---|---|
| Number of observations | 48300 |
| Missing cells | 1563 (0.1%) |
| Duplicate rows | 27 (0.1%) |
| Total size in memory | 12.5 MiB |
| Average record size in memory | 272.0 B |
Variables types
| Numeric | 5 |
|---|---|
| Categorical | 5 |
| Boolean | 23 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 1 |
| Unsupported | 0 |
Warnings
| Dataset has 27 (0.1%) duplicate rows | Warning |
bedrooms has 9436 (19.5%) zeros | Zeros |
created only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
created has a high cardinality: 47643 distinct values | Warning |
description has a high cardinality: 37491 distinct values | Warning |
description has 1421 (2.9%) missing values | Missing |
display_address has a high cardinality: 8692 distinct values | Warning |
dogs_allowed is highly correlated with cats_allowed (ρ = 0.93678) | Rejected |
street_address has a high cardinality: 15094 distinct values | Warning |
balcony
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2826 |
| Value | Count | Frequency (%) | |
| 0 | 45474 | 94.1% | |
| 1 | 2826 | 5.9% |
bathrooms
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.1783 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros (%) | 0.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.42612 |
|---|---|
| Coef of variation | 0.36164 |
| Kurtosis | 8.2552 |
| Mean | 1.1783 |
| MAD | 0.30508 |
| Skewness | 2.1167 |
| Sum | 56912 |
| Variance | 0.18158 |
| Memory size | 377.4 KiB |
| Value | Count | Frequency (%) | |
| 1 | 39337 | 81.4% | |
| 2 | 7416 | 15.4% | |
| 1.5 | 642 | 1.3% | |
| 3 | 354 | 0.7% | |
| 0 | 300 | 0.6% | |
| 2.5 | 190 | 0.4% | |
| 4 | 45 | 0.1% | |
| 3.5 | 14 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 4.5 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 300 | 0.6% | |
| 1 | 39337 | 81.4% | |
| 1.5 | 642 | 1.3% | |
| 2 | 7416 | 15.4% | |
| 2.5 | 190 | 0.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 1 | < 0.1% | |
| 4.5 | 1 | < 0.1% | |
| 4 | 45 | 0.1% | |
| 3.5 | 14 | < 0.1% | |
| 3 | 354 | 0.7% |
bedrooms
Numeric
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.5088 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros (%) | 19.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.0922 |
|---|---|
| Coef of variation | 0.72391 |
| Kurtosis | -0.17199 |
| Mean | 1.5088 |
| MAD | 0.92068 |
| Skewness | 0.43392 |
| Sum | 72875 |
| Variance | 1.193 |
| Memory size | 377.4 KiB |
| Value | Count | Frequency (%) | |
| 1 | 15718 | 32.5% | |
| 2 | 14451 | 29.9% | |
| 0 | 9436 | 19.5% | |
| 3 | 6777 | 14.0% | |
| 4 | 1710 | 3.5% | |
| 5 | 169 | 0.3% | |
| 6 | 36 | 0.1% | |
| 8 | 2 | < 0.1% | |
| 7 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 9436 | 19.5% | |
| 1 | 15718 | 32.5% | |
| 2 | 14451 | 29.9% | |
| 3 | 6777 | 14.0% | |
| 4 | 1710 | 3.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8 | 2 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 6 | 36 | 0.1% | |
| 5 | 169 | 0.3% | |
| 4 | 1710 | 3.5% |
cats_allowed
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 25227 | 52.2% | |
| 1 | 23073 | 47.8% |
common_outdoor_space
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1273 |
| Value | Count | Frequency (%) | |
| 0 | 47027 | 97.4% | |
| 1 | 1273 | 2.6% |
created
Categorical
| Distinct count | 47643 |
|---|---|
| Unique (%) | 98.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2016-05-27 03:59:28 | 3 |
|---|---|
| 2016-06-16 04:08:35 | 3 |
| 2016-06-25 01:30:16 | 3 |
| Other values (47640) |
| Value | Count | Frequency (%) | |
| 2016-05-27 03:59:28 | 3 | < 0.1% | |
| 2016-06-16 04:08:35 | 3 | < 0.1% | |
| 2016-06-25 01:30:16 | 3 | < 0.1% | |
| 2016-05-14 01:11:03 | 3 | < 0.1% | |
| 2016-04-15 02:24:25 | 3 | < 0.1% | |
| 2016-06-21 04:44:43 | 3 | < 0.1% | |
| 2016-04-08 01:14:27 | 3 | < 0.1% | |
| 2016-06-12 13:20:45 | 3 | < 0.1% | |
| 2016-06-12 12:30:28 | 3 | < 0.1% | |
| 2016-06-05 01:32:36 | 3 | < 0.1% | |
| Other values (47633) | 48270 | 99.9% |
| Max length | 19 |
|---|---|
| Mean length | 19 |
| Min length | 19 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
description
Categorical
| Distinct count | 37491 |
|---|---|
| Unique (%) | 77.6% |
| Missing (%) | 2.9% |
| Missing (n) | 1421 |
| 1614 | |
| <p><a website_redacted | 322 |
| 231 | |
| Other values (37487) | |
| (Missing) | 1421 |
| Value | Count | Frequency (%) | |
| 1614 | 3.3% | ||
| <p><a website_redacted | 322 | 0.7% | |
| 231 | 0.5% | ||
| A detailed description is coming soon. Please contact your Highline Residential agent with any questions. | 123 | 0.3% | |
| These pictures are from a similarlisting. | 64 | 0.1% | |
| I have total market coverage in Manhattan with access to show several thousand available apartments in the city through my real-time database of listings and co-broke network. CONTACT ME FOR AN EXCLUSIVE TOUR OF THIS AND OTHER GREAT APARTMENTS. TWITTER @NYCREAGENT<br /><br />Bond New York is a real estate broker that supports equal housing opportunity.<p><a website_redacted | 36 | 0.1% | |
| This renovated gorgeous apartment with spacious layout comes with hardwood floors, updated kitchen, updated bathroom, storage space. It is located in a well maintained video security elevator laundry building within a five minute walk to the subway. All buildings come with Bed Bug certifications. Cable and High Speed Internet, Heat and Hot Water Included. Showing Today! Schedule on-line at:www.MyManhattanapt.com<br/><br/>Schedule your showing today on-line at:www.MyManhattanapt.comShowing times: 8:45am, 10:15am, 11:45am, 1:15pm, 2:45am, 4:15pm, 5:45pm, 6:30pm, 7:30pmRequirements & Documents: Letter of employment, last year's tax return, recent bank statement. Shares ok, guarantors welcome (same documents needed)*No fee conditions apply <br/><br/><br/><br/><p> | 33 | 0.1% | |
| Modern renovations throughout, with flowing spacious layout, updated electric wiring, hardwood floors, updated kitchen, updated bathroom, storage space. It is located in a well maintained video security elevator laundry building within a five minute walk to the subway. All buildings come with Bed Bug certifications. Cable and High Speed Internet, Heat and Hot Water Included. Showing Today! Schedule on-line at:www.MyManhattanapt.com<br/><br/>Schedule your showing today on-line at:www.MyManhattanapt.comShowing times: 8:45am, 10:15am,11:45am, 1:15pm, 2:45am, 4:15pm, 5:45pm, 6:30pm, 7:30pmRequirements & Documents: Letter of employment, last year's tax return, recent bank statement. Shares ok, guarantors welcome (same documents needed)*No fee conditions apply <br/><br/><br/><br/><p> | 32 | 0.1% | |
| StuyTown offers an unbeatable combination of city energy and community tranquility. Conveniently located next to the East Village and Gramercy, the apartments are newly renovated, featuring hardwood floors, high ceilings, and custom, modern kitchens & bathrooms. Our no-fee, pet friendly community offers incredible amenities: a full-service onsite concierge, state of the art gym, 15 recreation areas & playgrounds, and 80 acres of beautifully landscaped green space. | 30 | 0.1% | |
| Actual Apartment Photos<br /><br />Bond New York is a real estate broker that supports equal housing opportunity.<p><a website_redacted | 27 | 0.1% | |
| Other values (37480) | 44367 | 91.9% | |
| (Missing) | 1421 | 2.9% |
| Max length | 4466 |
|---|---|
| Mean length | 597.63 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
dining_room
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 4665 |
| Value | Count | Frequency (%) | |
| 0 | 43635 | 90.3% | |
| 1 | 4665 | 9.7% |
dishwasher
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 28526 | 59.1% | |
| 1 | 19774 | 40.9% |
display_address
Categorical
| Distinct count | 8692 |
|---|---|
| Unique (%) | 18.0% |
| Missing (%) | 0.3% |
| Missing (n) | 132 |
| Broadway | 424 |
|---|---|
| East 34th Street | 354 |
| Second Avenue | 348 |
| Other values (8688) |
| Value | Count | Frequency (%) | |
| Broadway | 424 | 0.9% | |
| East 34th Street | 354 | 0.7% | |
| Second Avenue | 348 | 0.7% | |
| Wall Street | 330 | 0.7% | |
| West 37th Street | 287 | 0.6% | |
| West Street | 256 | 0.5% | |
| First Avenue | 244 | 0.5% | |
| Gold Street | 241 | 0.5% | |
| Washington Street | 226 | 0.5% | |
| York Avenue | 220 | 0.5% | |
| Other values (8681) | 45238 | 93.7% |
| Max length | 474 |
|---|---|
| Mean length | 13.586 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
dogs_allowed
Highly correlated
This variable is highly correlated with cats_allowed and should be ignored for analysis
| Correlation | 0.93678 |
|---|
doorman
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 28120 | 58.2% | |
| 1 | 20180 | 41.8% |
elevator
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 25135 | 52.0% | |
| 0 | 23165 | 48.0% |
exclusive
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2107 |
| Value | Count | Frequency (%) | |
| 0 | 46193 | 95.6% | |
| 1 | 2107 | 4.4% |
fitness_center
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 35570 | 73.6% | |
| 1 | 12730 | 26.4% |
garden_patio
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1835 |
| Value | Count | Frequency (%) | |
| 0 | 46465 | 96.2% | |
| 1 | 1835 | 3.8% |
hardwood_floors
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 25378 | 52.5% | |
| 1 | 22922 | 47.5% |
high_speed_internet
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 4146 |
| Value | Count | Frequency (%) | |
| 0 | 44154 | 91.4% | |
| 1 | 4146 | 8.6% |
interest_level
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| low | |
|---|---|
| medium | |
| high | 3827 |
| Value | Count | Frequency (%) | |
| low | 33270 | 68.9% | |
| medium | 11203 | 23.2% | |
| high | 3827 | 7.9% |
| Max length | 6 |
|---|---|
| Mean length | 3.7751 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
latitude
Numeric
| Distinct count | 2302 |
|---|---|
| Unique (%) | 4.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 40.751 |
|---|---|
| Minimum | 40.571 |
| Maximum | 40.915 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 40.571 |
|---|---|
| 5-th percentile | 40.689 |
| Q1 | 40.728 |
| Median | 40.752 |
| Q3 | 40.774 |
| 95-th percentile | 40.82 |
| Maximum | 40.915 |
| Range | 0.3442 |
| Interquartile range | 0.0459 |
Descriptive statistics
| Standard deviation | 0.03956 |
|---|---|
| Coef of variation | 0.00097078 |
| Kurtosis | 1.6455 |
| Mean | 40.751 |
| MAD | 0.029743 |
| Skewness | -0.083905 |
| Sum | 1.9683e+06 |
| Variance | 0.001565 |
| Memory size | 377.4 KiB |
| Value | Count | Frequency (%) | |
| 40.753 | 299 | 0.6% | |
| 40.757 | 298 | 0.6% | |
| 40.73 | 245 | 0.5% | |
| 40.707 | 244 | 0.5% | |
| 40.707 | 236 | 0.5% | |
| 40.744 | 233 | 0.5% | |
| 40.707 | 223 | 0.5% | |
| 40.761 | 215 | 0.4% | |
| 40.708 | 213 | 0.4% | |
| 40.761 | 211 | 0.4% | |
| Other values (2292) | 45883 | 95.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 40.571 | 1 | < 0.1% | |
| 40.576 | 4 | < 0.1% | |
| 40.576 | 18 | < 0.1% | |
| 40.576 | 1 | < 0.1% | |
| 40.577 | 11 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 40.915 | 1 | < 0.1% | |
| 40.914 | 1 | < 0.1% | |
| 40.91 | 3 | < 0.1% | |
| 40.909 | 3 | < 0.1% | |
| 40.907 | 1 | < 0.1% |
laundry_in_building
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2566 |
| Value | Count | Frequency (%) | |
| 0 | 45734 | 94.7% | |
| 1 | 2566 | 5.3% |
laundry_in_unit
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 40146 | 83.1% | |
| 1 | 8154 | 16.9% |
loft
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1993 |
| Value | Count | Frequency (%) | |
| 0 | 46307 | 95.9% | |
| 1 | 1993 | 4.1% |
longitude
Numeric
| Distinct count | 1641 |
|---|---|
| Unique (%) | 3.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -73.972 |
|---|---|
| Minimum | -74.094 |
| Maximum | -73.7 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -74.094 |
|---|---|
| 5-th percentile | -74.009 |
| Q1 | -73.992 |
| Median | -73.978 |
| Q3 | -73.955 |
| 95-th percentile | -73.926 |
| Maximum | -73.7 |
| Range | 0.3939 |
| Interquartile range | 0.037 |
Descriptive statistics
| Standard deviation | 0.029563 |
|---|---|
| Coef of variation | -0.00039964 |
| Kurtosis | 7.5716 |
| Mean | -73.972 |
| MAD | 0.021815 |
| Skewness | 1.841 |
| Sum | -3.5729e+06 |
| Variance | 0.00087394 |
| Memory size | 377.4 KiB |
| Value | Count | Frequency (%) | |
| -73.998 | 292 | 0.6% | |
| -73.987 | 268 | 0.6% | |
| -73.986 | 264 | 0.5% | |
| -73.984 | 247 | 0.5% | |
| -74.015 | 238 | 0.5% | |
| -74.005 | 222 | 0.5% | |
| -73.984 | 216 | 0.4% | |
| -73.973 | 210 | 0.4% | |
| -73.979 | 205 | 0.4% | |
| -74.006 | 199 | 0.4% | |
| Other values (1631) | 45939 | 95.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -74.094 | 1 | < 0.1% | |
| -74.087 | 1 | < 0.1% | |
| -74.085 | 1 | < 0.1% | |
| -74.082 | 1 | < 0.1% | |
| -74.08 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -73.7 | 7 | < 0.1% | |
| -73.714 | 6 | < 0.1% | |
| -73.739 | 1 | < 0.1% | |
| -73.749 | 1 | < 0.1% | |
| -73.75 | 1 | < 0.1% |
new_construction
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2438 |
| Value | Count | Frequency (%) | |
| 0 | 45862 | 95.0% | |
| 1 | 2438 | 5.0% |
no_fee
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 30750 | 63.7% | |
| 1 | 17550 | 36.3% |
outdoor_space
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 6560 |
| Value | Count | Frequency (%) | |
| 0 | 41740 | 86.4% | |
| 1 | 6560 | 13.6% |
pre-war
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 39323 | 81.4% | |
| 1 | 8977 | 18.6% |
price
Numeric
| Distinct count | 2583 |
|---|---|
| Unique (%) | 5.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3438.3 |
|---|---|
| Minimum | 1025 |
| Maximum | 9999 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1025 |
|---|---|
| 5-th percentile | 1800 |
| Q1 | 2495 |
| Median | 3100 |
| Q3 | 4000 |
| 95-th percentile | 6250 |
| Maximum | 9999 |
| Range | 8974 |
| Interquartile range | 1505 |
Descriptive statistics
| Standard deviation | 1401.4 |
|---|---|
| Coef of variation | 0.40759 |
| Kurtosis | 2.2299 |
| Mean | 3438.3 |
| MAD | 1056 |
| Skewness | 1.3722 |
| Sum | 1.6607e+08 |
| Variance | 1.964e+06 |
| Memory size | 377.4 KiB |
| Value | Count | Frequency (%) | |
| 2500 | 1106 | 2.3% | |
| 3200 | 879 | 1.8% | |
| 3000 | 837 | 1.7% | |
| 2700 | 776 | 1.6% | |
| 2400 | 771 | 1.6% | |
| 2600 | 707 | 1.5% | |
| 3500 | 691 | 1.4% | |
| 2800 | 669 | 1.4% | |
| 2300 | 642 | 1.3% | |
| 3400 | 637 | 1.3% | |
| Other values (2573) | 40585 | 84.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1025 | 1 | < 0.1% | |
| 1034 | 2 | < 0.1% | |
| 1048 | 1 | < 0.1% | |
| 1050 | 5 | < 0.1% | |
| 1095 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9999 | 3 | < 0.1% | |
| 9995 | 10 | < 0.1% | |
| 9990 | 1 | < 0.1% | |
| 9987 | 1 | < 0.1% | |
| 9977 | 1 | < 0.1% |
roof_deck
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 6320 |
| Value | Count | Frequency (%) | |
| 0 | 41980 | 86.9% | |
| 1 | 6320 | 13.1% |
street_address
Categorical
| Distinct count | 15094 |
|---|---|
| Unique (%) | 31.3% |
| Missing (%) | < 0.1% |
| Missing (n) | 10 |
| 3333 Broadway | 174 |
|---|---|
| 505 West 37th Street | 167 |
| 200 Water Street | 160 |
| Other values (15090) |
| Value | Count | Frequency (%) | |
| 3333 Broadway | 174 | 0.4% | |
| 505 West 37th Street | 167 | 0.3% | |
| 200 Water Street | 160 | 0.3% | |
| 90 Washington Street | 142 | 0.3% | |
| 100 Maiden Lane | 131 | 0.3% | |
| 401 East 34th Street | 129 | 0.3% | |
| 2 Gold Street | 120 | 0.2% | |
| 1 West Street | 119 | 0.2% | |
| 100 John Street | 115 | 0.2% | |
| 95 Wall Street | 106 | 0.2% | |
| Other values (15083) | 46927 | 97.2% |
| Max length | 78 |
|---|---|
| Mean length | 16.677 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
swimming_pool
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2560 |
| Value | Count | Frequency (%) | |
| 0 | 45740 | 94.7% | |
| 1 | 2560 | 5.3% |
terrace
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 2118 |
| Value | Count | Frequency (%) | |
| 0 | 46182 | 95.6% | |
| 1 | 2118 | 4.4% |
wheelchair_access
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 1259 |
| Value | Count | Frequency (%) | |
| 0 | 47041 | 97.4% | |
| 1 | 1259 | 2.6% |
First rows
| balcony | bathrooms | bedrooms | cats_allowed | common_outdoor_space | created | description | dining_room | dishwasher | display_address | dogs_allowed | doorman | elevator | exclusive | fitness_center | garden_patio | hardwood_floors | high_speed_internet | interest_level | latitude | laundry_in_building | laundry_in_unit | loft | longitude | new_construction | no_fee | outdoor_space | pre-war | price | roof_deck | street_address | swimming_pool | terrace | wheelchair_access | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 1.5 | 3 | 0 | 0 | 2016-06-24 07:54:24 | A Brand New 3 Bedroom 1.5 bath ApartmentEnjoy ... | 0 | 0 | Metropolitan Avenue | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | medium | 40.7145 | 0 | 0 | 0 | -73.9425 | 0 | 0 | 0 | 0 | 3000 | 0 | 792 Metropolitan Avenue | 0 | 0 | 0 |
| 1 | 0 | 1.0 | 2 | 1 | 0 | 2016-06-12 12:19:27 | 0 | 0 | Columbus Avenue | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | low | 40.7947 | 0 | 0 | 0 | -73.9667 | 0 | 0 | 0 | 0 | 5465 | 0 | 808 Columbus Avenue | 0 | 0 | 0 | |
| 2 | 0 | 1.0 | 1 | 0 | 0 | 2016-04-17 03:26:41 | Top Top West Village location, beautiful Pre-w... | 0 | 1 | W 13 Street | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | high | 40.7388 | 1 | 0 | 0 | -74.0018 | 0 | 0 | 0 | 0 | 2850 | 0 | 241 W 13 Street | 0 | 0 | 0 |
| 3 | 0 | 1.0 | 1 | 0 | 0 | 2016-04-18 02:22:02 | Building Amenities - Garage - Garden - fitness... | 0 | 0 | East 49th Street | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | low | 40.7539 | 0 | 0 | 0 | -73.9677 | 0 | 1 | 0 | 0 | 3275 | 0 | 333 East 49th Street | 0 | 0 | 0 |
| 4 | 0 | 1.0 | 4 | 0 | 0 | 2016-04-28 01:32:41 | Beautifully renovated 3 bedroom flex 4 bedroom... | 0 | 0 | West 143rd Street | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | low | 40.8241 | 0 | 0 | 0 | -73.9493 | 0 | 0 | 0 | 1 | 3350 | 0 | 500 West 143rd Street | 0 | 0 | 0 |
| 5 | 0 | 2.0 | 4 | 0 | 0 | 2016-04-19 04:24:47 | 0 | 0 | West 18th Street | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | medium | 40.7429 | 0 | 0 | 0 | -74.0028 | 0 | 0 | 0 | 0 | 7995 | 0 | 350 West 18th Street | 0 | 0 | 0 | |
| 6 | 0 | 1.0 | 2 | 1 | 0 | 2016-04-27 03:19:56 | Stunning unit with a great location and lots o... | 0 | 0 | West 107th Street | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | low | 40.8012 | 0 | 0 | 0 | -73.9660 | 0 | 1 | 0 | 0 | 3600 | 0 | 210 West 107th Street | 0 | 0 | 0 |
| 7 | 0 | 2.0 | 1 | 0 | 0 | 2016-04-13 06:01:42 | This huge sunny ,plenty of lights 1 bed/2 bath... | 0 | 1 | West 21st Street | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | low | 40.7427 | 0 | 1 | 0 | -73.9957 | 0 | 0 | 1 | 1 | 5645 | 0 | 155 West 21st Street | 0 | 1 | 0 |
| 8 | 0 | 1.0 | 1 | 1 | 0 | 2016-04-20 02:36:35 | <p><a website_redacted | 0 | 0 | Hamilton Terrace | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | medium | 40.8234 | 1 | 0 | 0 | -73.9457 | 0 | 0 | 0 | 0 | 1725 | 0 | 63 Hamilton Terrace | 0 | 0 | 0 |
| 9 | 0 | 2.0 | 4 | 0 | 0 | 2016-04-02 02:58:15 | This is a spacious four bedroom with every bed... | 0 | 1 | 522 E 11th | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | low | 40.7278 | 0 | 0 | 0 | -73.9808 | 0 | 0 | 0 | 0 | 5800 | 0 | 522 E 11th | 0 | 0 | 0 |
Last rows
| balcony | bathrooms | bedrooms | cats_allowed | common_outdoor_space | created | description | dining_room | dishwasher | display_address | dogs_allowed | doorman | elevator | exclusive | fitness_center | garden_patio | hardwood_floors | high_speed_internet | interest_level | latitude | laundry_in_building | laundry_in_unit | loft | longitude | new_construction | no_fee | outdoor_space | pre-war | price | roof_deck | street_address | swimming_pool | terrace | wheelchair_access | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48290 | 0 | 1.0 | 1 | 1 | 0 | 2016-04-07 02:29:00 | LUXURY BUILDING IN MIDTOWN WEST, 24 HR DOORMAN... | 0 | 1 | W 54 St. | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | high | 40.7645 | 0 | 0 | 0 | -73.9840 | 1 | 1 | 0 | 0 | 2500 | 0 | 260 W 54 St. | 0 | 0 | 0 |
| 48291 | 0 | 1.0 | 1 | 0 | 0 | 2016-04-02 03:17:03 | Huge true king size one bedroom in an elevator... | 0 | 1 | E 76 Street | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | low | 40.7728 | 0 | 0 | 0 | -73.9591 | 0 | 1 | 0 | 0 | 2675 | 0 | 191 E 76 Street | 0 | 0 | 0 |
| 48292 | 0 | 1.0 | 1 | 0 | 0 | 2016-04-14 03:39:42 | Charming one bedroom! Hardwood floors, sunny, ... | 0 | 0 | Charles Street | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | low | 40.7350 | 0 | 0 | 0 | -74.0007 | 0 | 0 | 0 | 0 | 3645 | 0 | 6 Charles Street | 0 | 0 | 0 |
| 48293 | 0 | 1.0 | 1 | 0 | 0 | 2016-04-11 03:29:05 | **89th & Park Ave! (block from the central par... | 0 | 1 | East 89th Street | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | low | 40.7889 | 0 | 0 | 0 | -73.9719 | 0 | 0 | 0 | 0 | 2179 | 0 | 117 East 89th Street | 0 | 0 | 0 |
| 48294 | 0 | 1.0 | 1 | 1 | 0 | 2016-04-22 15:44:11 | 24hr Doorman Luxury building in the heart of t... | 0 | 0 | East 10th Street | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | medium | 40.7296 | 1 | 0 | 0 | -73.9869 | 0 | 1 | 0 | 0 | 4500 | 0 | 166 2nd avenue | 0 | 0 | 0 |
| 48295 | 0 | 1.0 | 2 | 0 | 0 | 2016-06-02 05:41:05 | 30TH/3RD, MASSIVE CONV 2BR IN LUXURY FULL SERV... | 0 | 1 | E 30 St | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | medium | 40.7426 | 0 | 1 | 0 | -73.9790 | 0 | 1 | 0 | 0 | 3200 | 0 | 230 E 30 St | 0 | 0 | 0 |
| 48296 | 0 | 1.0 | 1 | 1 | 1 | 2016-04-04 18:22:34 | HIGH END condo finishes, swimming pool, and ki... | 0 | 0 | Rector Pl | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | low | 40.7102 | 1 | 0 | 0 | -74.0163 | 0 | 0 | 1 | 0 | 3950 | 0 | 225 Rector Place | 0 | 0 | 0 |
| 48297 | 0 | 1.0 | 1 | 1 | 0 | 2016-04-16 02:13:40 | Large Renovated One Bedroom Apartment with Sta... | 0 | 0 | West 45th Street | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | low | 40.7601 | 0 | 0 | 0 | -73.9900 | 0 | 0 | 0 | 1 | 2595 | 0 | 341 West 45th Street | 0 | 0 | 0 |
| 48298 | 0 | 1.0 | 0 | 1 | 0 | 2016-04-08 02:13:33 | Stylishly sleek studio apartment with unsurpas... | 0 | 0 | Wall Street | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | low | 40.7066 | 0 | 0 | 0 | -74.0101 | 0 | 0 | 0 | 1 | 3350 | 0 | 37 Wall Street | 0 | 0 | 0 |
| 48299 | 0 | 1.0 | 2 | 0 | 0 | 2016-04-12 02:48:07 | Look no further!!! This giant 2 bedroom apart... | 0 | 0 | Park Terrace East | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | low | 40.8699 | 0 | 0 | 0 | -73.9172 | 0 | 0 | 0 | 0 | 2200 | 0 | 30 Park Terrace East | 0 | 0 | 0 |